CREATE PROCEDURE [dbo].[AppointmentDelete] 
@UBRN		INT

AS

DELETE 
FROM	Appointment
WHERE	UBRN = @UBRN
	
RETURN @@ROWCOUNT